The Jiwa CSV Import utility reads a given CSV file and imports the file into Jiwa. Configure the utility by editing the JiwaCSVImport.exe.config file using any text editor (such as notepad). It is recommended this be done on one machine only on the network, preferably a server. The content of the file is detailed below:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="Server" value=" />
<add key="Database" value="JiwaDemo" />
<add key="SQLLogin" value="sa" />
<add key="SQLPassword" value=" />
<add key="SourceFileContainsHeaderRow" value="TRUE" />
<add key="JiwaLogin" value="Admin" />
<add key="JiwaPassword" value="password" />
<add key="JiwaINIFilePath" value="C:\Program Files\Jiwa Financials\Jiwa\Jiwa.xml" />
<add key="LogicalWarehouseID" value="ZZZZZZZZZZ0000000000" />
<add key="VerboseLogging" value="TRUE" />
<add key="LogToApplicationLog" value="TRUE" />
<add key="LogToFile" value="TRUE" />
<add key="LogFileName" value="C:\Program Files\Jiwa Financials\Jiwa\Jiwa CSV Import\JiwaCSVImport.log" />
<add key="SQLCommandTimeoutInSeconds" value="30" />
<add key="NameOfStoredProcedureToValidateData" value="usp_JIWA_JIB_GenericCSVDataValidate" />
<add key="NameOfStoredProcedureToConvertData" value="usp_JIWA_JIB_GenericCSVDataConvert" />
</appSettings>
</configuration>
This configuration needs to be modified to work with Paxar as follows:
Copyright © 2012 Jiwa Financials. All rights reserved.